🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-28 🟢

🔹 [Target] Optimize and Automate Emerging Risk Dashboard [Method] Python, VBA, APIs, Web Scraping [UI/UX] Excel Dashboards [Stack] Python (Pandas, Requests, BeautifulSoup), VBA, Excel Formulas, Power Query [Security] NDA, Secure Data Handling [Format] JSON
👤 Client: 🇦🇺 Australia Member since 2021-01-09
💰 Price: $2,000
🚩 Problem: Manual data collection and update process for the Emerging Risk Dashboard is time-consuming and error-prone.
📦 Existing: Not specified

Specifications:

[Target] Automate or semi-automate retrieval and processing of about 40 key indicators from structured (APIs, databases) and unstructured sources (PDFs, proprietary reports).
[Method] Use Python for APIs and web scraping; VBA for Excel updates.
[UI/UX] Enhance dashboard with clear visual elements like color-coded triggers and summaries.
[Stack] Python (Pandas, Requests, BeautifulSoup, Selenium), VBA, Power Query, Excel Formulas.
[Security] Sign NDA to protect sensitive data and processes.
[Format] Deliverables in JSON format for easy integration.

Workflow:

1. Identify and document all key indicators from structured and unstructured sources.
2. Develop Python scripts for API calls, web scraping, and data parsing from PDFs or other unstructured formats.
3. Integrate automated feeds into the Excel workbook using VBA and Power Query.
4. Automate rolling mean, standard deviation, and threshold calculations.
5. Set up push-notification mechanisms for monthly updates.
6. Review and refine existing formulas for accuracy and speed.
7. Enhance alert system with intuitive formatting (color-coded triggers, error handling).
8. Reorganize workbook by removing unnecessary sheets and redundant formulas.
9. Design future-ready dashboard to easily add new indicators via documented process.
10. Create user-friendly instruction manual detailing how to add new indicators, maintain data sources, and troubleshoot issues.